www.gusucode.com > PHP展示型企业网站模板米拓整站源码 1.0PHP源码程序 > PHP展示型企业网站模板米拓整站源码 1.0/MetInfozs_v1.0/MetInfozs_v1.0/admin/system/database/index.php

    <?php
# MetInfo Enterprise Content Management System 
# Copyright (C) MetInfo Co.,Ltd (http://www.metinfo.cn). All rights reserved. 
$depth='../';
require_once $depth.'../login/login_check.php';
require_once 'global.func.php';
$cs=isset($cs)?$cs:1;
$listclass[$cs]='class="now"';
$labtype=isset($labtype)?($labtype==''?1:$labtype):1;
$labtypeclass[$labtype]='class="now"';
$css_url=$depth."../templates/".$met_skin."/css";
$img_url=$depth."../templates/".$met_skin."/images";
$rurls='../system/database/filedown.php?anyid='.$anyid.'&lang='.$lang.'&cs=6';
$tables = '';
if($action=='allfile'){
	echo "<span id=\"tips\">$lang_setdbArchiveNo</span>";
	$localurl="http://";
	$localurl.=$_SERVER['HTTP_HOST'].$_SERVER["PHP_SELF"];
	$localurl_a=explode("/",$localurl);
	$localurl_count=count($localurl_a);
	$localurl_admin=$localurl_a[$localurl_count-4];
	$localurl_admin=$localurl_admin."/system/database/index";
	$localurl_real=explode($localurl_admin,$localurl);
	$localurl=$localurl_real[0];
	$fileid = isset($fileid)?$fileid:1;
	$tables=tableprearray($tablepre);
	$sizelimit=2048;
	if($fileid==1){
		$random = met_rand(6);
		cache_write('bakup_tables.php', $tables);
	}
	$sqldump = '';
	$tableid = isset($tableid) ? $tableid - 1 : 0;
	$startfrom = isset($startfrom) ? intval($startfrom) : 0;
	$tablenumber = count($tables);
	for($i = $tableid; $i < $tablenumber && strlen($sqldump) < $sizelimit * 1000; $i++){
		$sqldump .= sql_dumptable($tables[$i], $startfrom, strlen($sqldump));
		$startfrom = 0;
	}
	include "../../include/pclzip.lib.php";
	if(trim($sqldump)){
		$version='version:'.$metcms_v;
		$sqldump = "#MetInfo.cn Created {$version} \n#$localurl\n#$tablepre\n# --------------------------------------------------------\n\n\n".$sqldump;
		$tableid = $i;
		$filename = $con_db_name.'_'.date('Ymd').'_'.$random.'_'.$fileid.'.sql';
		$zipname  = $con_db_name.'_'.date('Ymd').'_'.$random.'_'.$fileid;
		$fileid++;
		$bakfile = '../../databack/'.$filename;
		if(!is_writable('../../databack/'))metsave('-1',$lang_setdbTip2.'databack/'.$lang_setdbTip3,$depth);  
		file_put_contents($bakfile, $sqldump);
		if(!file_exists('../../databack/sql'))@mkdir ('../../databack/sql', 0777);  
		$sqlzip='../../databack/sql/'.$met_agents_backup.'_'.$zipname.'.zip';
		$archive = new PclZip($sqlzip);
		$zip_list = $archive->create('../../databack/'.$filename,PCLZIP_OPT_REMOVE_PATH,'../../databack/');
		if($zip_list == 0){
			//die("Error : ".$archive->errorInfo(true));
			metsave($rurls,$lang_setdbArchiveNo,$depth);
		}
		header('location:index.php?lang='.$lang.'&data_msg='.$data_msg.'&action='.$action.'&sizelimit='.$sizelimit.'&tableid='.$tableid.'&fileid='.$fileid.'&startfrom='.$startrow.'&random='.$random.'&anyid='.$anyid.'&cs='.$cs);
	}else{
		cache_delete('bakup_tables.php');
		$adminfile=$url_array[count($url_array)-2];
		if(!file_exists('../../databack/web'))@mkdir ('../../databack/web', 0777);  
		
		$sqlzip='../../databack/web/'.$met_agents_backup.'_web_'.$con_db_name.'_'.date('YmdHis',time()).'_'.met_rand(6).'.zip';
		$zipfile="../../../";
		$archive = new PclZip($sqlzip);
		$zip_list = $archive->create($zipfile,PCLZIP_OPT_REMOVE_PATH,'../../../',PCLZIP_CB_PRE_ADD,'myPreAddCallBack');
		if($zip_list==0){
			//die("Error : ".$archive->errorInfo(true));
			metsave($rurls,$lang_setdbArchiveNo,$depth);
		}
		echo "<script type=\"text/javascript\">document.getElementById('tips').style.display = \"none\";</script>";
		metsave($rurls,$lang_setdbArchiveOK,$depth);
	}
}elseif($action=='uploadimg'){
	echo "<span id=\"tips\">$lang_setdbArchiveNo</span>";
	include "../../include/pclzip.lib.php";
	if(!file_exists('../../databack/upload'))@mkdir ('../../databack/upload', 0777);  
	$sqlzip='../../databack/upload/'.$met_agents_backup.'_upload_'.date('YmdHis',time()).'.zip';
	$zipfile="../../../upload";
	$archive = new PclZip($sqlzip);
	$zip_list = $archive->create($zipfile,PCLZIP_OPT_REMOVE_PATH,'../../../');
	if ($zip_list == 0) {
		//die("Error : ".$archive->errorInfo(true));
		metsave($rurls,$lang_setdbArchiveNo,$depth);
	}
	metsave($rurls,$lang_setdbArchiveOK,$depth);
}elseif($action=='config'){
	foreach($met_langok as $key=>$val){
		if(file_exists("../../../config/config_".$val[mark].".inc.php"))$zipfile.="../../../config/config_".$val[mark].".inc.php,";
		if(file_exists("../../../config/flash_".$val[mark].".inc.php"))$zipfile.="../../../config/flash_".$val[mark].".inc.php,";
		if(file_exists("../../../config/str_".$val[mark].".inc.php"))$zipfile.="../../../config/str_".$val[mark].".inc.php,";
		if(file_exists("../../../config/feedback_".$val[mark].".inc.php"))$zipfile.="../../../config/feedback_".$val[mark].".inc.php,";
		if(file_exists("../../../config/job_".$val[mark].".inc.php"))$zipfile.="../../../config/job_".$val[mark].".inc.php,";
		if(file_exists("../../../config/message_".$val[mark].".inc.php"))$zipfile.="../../../config/message_".$val[mark].".inc.php,";
	}
	include "../../include/pclzip.lib.php";
	if(!file_exists('../../databack/config'))@mkdir ('../../databack/config', 0777);  
	$sqlzip='../../databack/config/'.$met_agents_backup.'_config_'.date('YmdHis',time()).'.zip';
	$zipfile.="../../../lang,../../../config/lang.inc.php,../../../config/config_db.php";
	$archive = new PclZip($sqlzip);
	$zip_list = $archive->create($zipfile,PCLZIP_OPT_REMOVE_PATH,'../../../');
	if ($zip_list == 0) {
		//die("Error : ".$archive->errorInfo(true));
		metsave($rurls,$lang_setdbArchiveNo,$depth);
	}
	echo "<script type=\"text/javascript\">document.getElementById('tips').style.display = \"none\";</script>";
	metsave($rurls,$lang_setdbArchiveOK,$depth);
}elseif($action=='allbase'){
	$localurl="http://";
	$localurl.=$_SERVER['HTTP_HOST'].$_SERVER["PHP_SELF"];
	$localurl_a=explode("/",$localurl);
	$localurl_count=count($localurl_a);
	$localurl_admin=$localurl_a[$localurl_count-4];
	$localurl_admin=$localurl_admin."/system/database/index";
	$localurl_real=explode($localurl_admin,$localurl);
	$localurl=$localurl_real[0];
	$fileid = isset($fileid)?$fileid:1;
	if($tbl){
		$tables=tableprearray($tablepre);
		$sizelimit=2048;
	}else{
		foreach($tables as $key=>$val){
			$tablestx.=$val.'|';
		}
	}
	if($fileid==1){
		$random =met_rand(6);
		cache_write('bakup_tables.php', $tables);
	}elseif(!$tbl){
		$allidlist=explode('|',$tablestx);
		for($i=0;$i<count($allidlist)-1;$i++){
			$tables[$i]=$allidlist[$i];
		}
	}
	$sqldump = '';
	$tableid = isset($tableid) ? $tableid - 1 : 0;
	$startfrom = isset($startfrom) ? intval($startfrom) : 0;
	$tablenumber = count($tables);
	for($i = $tableid; $i < $tablenumber && strlen($sqldump) < $sizelimit * 1000; $i++){
		$sqldump .= sql_dumptable($tables[$i], $startfrom, strlen($sqldump));
		$startfrom = 0;
	}
	if(trim($sqldump)){
		$version='version:'.$metcms_v;
		$sqldump = "#MetInfo.cn Created {$version} \n#$localurl\n#$tablepre\n# --------------------------------------------------------\n\n\n".$sqldump;
		$tableid = $i;
		$filename = $con_db_name.'_'.date('Ymd').'_'.$random.'_'.$fileid.'.sql';
		$zipname  = $con_db_name.'_'.date('Ymd').'_'.$random.'_'.$fileid;
		$fileid++;
		$bakfile = '../../databack/'.$filename;
		if(!is_writable('../../databack/'))metsave('-1',$lang_setdbTip2.'databack/'.$lang_setdbTip3,$depth); 
		file_put_contents($bakfile, $sqldump);
		include "../../include/pclzip.lib.php";
		if(!file_exists('../../databack/sql'))@mkdir ('../../databack/sql', 0777);  
		$sqlzip='../../databack/sql/'.$met_agents_backup.'_'.$zipname.'.zip';
		$archive = new PclZip($sqlzip);
		$zip_list = $archive->create('../../databack/'.$filename,PCLZIP_OPT_REMOVE_PATH,'../../databack/');
		if($zip_list == 0){
			//die("Error : ".$archive->errorInfo(true));
			metsave($rurls,$lang_setdbArchiveNo,$depth);
		}
		header('location:index.php?lang='.$lang.'&data_msg='.$data_msg.'&action='.$action.'&sizelimit='.$sizelimit.'&tableid='.$tableid.'&fileid='.$fileid.'&startfrom='.$startrow.'&random='.$random.'&anyid='.$anyid.'&tablestx='.$tablestx.'&tbl='.$tbl);
	}else{
		cache_delete('bakup_tables.php');
		metsave($rurls,$lang_setdbBackupOK,$depth);
	}
}
/*获取数据表*/
if($labtype==2){
	$size = $bktables = $bkresults = $results= array();
	$k = 0;
	$totalsize = 0;
	$query = $db->query("SHOW TABLES FROM ".$con_db_name);
	while($r = $db->fetch_row($query)){  
		if(strstr($r[0], $tablepre)){
			$tables[$k] = $r[0];
			$count = $db->get_one("SELECT count(*) as number FROM $r[0] WHERE 1");
			$results[$k] = $count['number'];
			$bktables[$k] = $r[0];
			$bkresults[$k] = $count['number'];
			$q = $db->query("OPTIMIZE TABLE $r[0]");
			$q = $db->query("SHOW TABLE STATUS FROM `".$con_db_name."` LIKE '".$r[0]."'");
			$s = $db->fetch_array($q);
			$size[$k] = round($s['Data_length']/1024/1024, 2);
			$totalsize += $size[$k];
			$k++;
		}
	}
}
include_once template('system/database/index');footer();
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.
?>